Cosmos DB (1 / 62): You are developing a system that needs to interact with Azure Cosmos DB. Your task is to write a piece of code that connects to a specific Cosmos DB instance and retrieves sales orders for a given account number, with a maximum item count of 1.
var connectionString = "<connection-string>";
var dbName = "<database>";
var containerName = "<container>";
var partitionKey = "Accounts";
var throughputValue = 400;
var accountNumber = "190823";
// Code here
Answer:
var connectionString = "<connection-string>";
var dbName = "<database>";
var containerName = "<container>";
var partitionKey = "Accounts";
var throughputValue = 400;
var accountNumber = "190823";
var cosmosClient = new CosmosClient(connectionString);
Database database = await cosmosClient.CreateDatabaseIfNotExistsAsync(dbName);
Container container = await database.CreateContainerIfNotExistsAsync(id: , partitionKeyPath: $"/{partitionKey}", throughput: throughputValue);
QueryDefinition query = new QueryDefinition(
"select * from sales s where s.AccountNumber = @AccountInput ")
.WithParameter("@AccountInput", accountNumber);
FeedIterator<SalesOrder> resultSet = container.GetItemQueryIterator<SalesOrder>(
query,
requestOptions: new QueryRequestOptions()
{
PartitionKey = new PartitionKey(partitionKey),
MaxItemCount = 1
});